FO_LabInfo
This table contains a single row.
Field |
Type |
Notes |
labinfo_id |
INT |
Identity (counter) field |
labname |
varchar(50) |
Laboratory name on the login screen and reports |
labcode |
varchar(20) |
Code value for this lab. |
labaddress1 |
varchar(50) |
Address field on reports . |
labaddress2 |
varchar(50) |
Second address field on reports . |
labaddress3 |
varchar(50) |
Third address field on reports. |
labaddress4 |
varchar(50) |
Fourth address field on reports |
labdirector |
varchar(50) |
Name of lab director on reports. |
misc1 |
varchar(50) |
Login screen user defined field #1. |
misc2 |
varchar(50) |
Login screen user defined field #2. |
misc3 |
varchar(50) |
Login screen user defined field #3. |
misc4 |
varchar(50) |
Login screen user defined field #4. |
misc5 |
varchar(50) |
Login screen user defined field #5. |
useverify |
int |
Use 1 Do NOT change without Rhodes Group approval. |
usemandatorysteps |
int |
Use 1 Do NOT change without Rhodes Group approval. |
barcode_security |
decimal(18, 2) |
Use 1 Do NOT change without Rhodes Group approval. |
barcode_xunit |
decimal(18, 2) |
Use 150.00 Do NOT change without Rhodes Group approval. |
barcode_yunit |
decimal(18, 2) |
Use 5.00 Do NOT change without Rhodes Group approval. |
def_ptloccode |
varchar(20) |
Default patient location code on the order screen. Use valid patient location code. |
def_epi_days |
int |
Use 30 Do NOT change without Rhodes Group approval. |
epi_ins_options |
varchar(100) |
Populates insurance option drop-down list on the episode definition screen. Multidimensional pipe delimited value. Use valid insurance options separated by pipes with leading and trailing pipes. IE: |INS1|INS2|INS3| |
epi_billto_options |
varchar(100) |
Populates billto option drop-down list on the episode definition screen. Multidimensional pipe delimited value. Use valid bill to options separated by pipes with leading and trailing pipes. IE: |P|C|I| |
SO_review_days |
int |
Default number of days before a standing order expires and requires review. Use an integer. Used to calculate the number of days until standing order expiration. IE: 180 |
resultsysurl |
varchar(255) |
URL to connect to a client-provided lab result portal. Use a valid URL. The URL may contain place holders for user name and password for the lab system. IE: HTTP://LabPortal.com /#USERNAME#/#PASSWORD# |
blockmrlength |
varchar(80) |
Mask for MRN entry value. Multidimensional pipe delimited value. Use integers separated by pipes with leading and trailing pipes. Each number represents a MRN entry length that is NOT supported by the system. IE: |1|2|3|4|5|6|7|9|10|11|12|13|14| In this example, the MRN entry must be either 8 characters long or longer than 14 characters. |
ADT_Interface |
varchar(255) |
Default value for the Outbound ADT system interface. Use Rhodes Group recommended value. |
OE_Interface |
varchar(255) |
Default value for the Outbound OE system interface. Use Rhodes Group recommended value. |
Result_Interface |
varchar(255) |
Default value for the Outbound RE system interface. Use Rhodes Group recommended value. |
logoimagefile |
varchar(255) |
The network path and file name for the logo file used on screen and report displays. Use a valid network path and file name. The file must be a GIF or JPG image approximately 100x125 pixels. |
defaultfacilityid |
varchar(50) |
Default system facility ID code. Use a valid facility ID code. |
defaultspeciescode |
varchar(50) |
Default species code. H = HUMAN |
defaultspeciesname |
varchar(50) |
Default species name corresponding to the default species code. HUMAN |
def_clientcode |
varchar(50) |
Default system client ID code. Use a valid client ID code. |
defOrdScreenReq |
varchar(80) |
Default requisition report name used when the REQ button on the order screen is clicked. Default used when the user-level value is not defined. Required value. Use Rhodes Group recommended value. |
callback_callcode |
varchar(50) |
Value for “Call” for callback systems. Used when the CALL button on the order screen phone definitions is clicked. |
callback_faxcode |
varchar(50) |
Value for “Fax” for callback systems. Used when the Fax button on the order screen phone definitions is clicked. |
mrnumgenerationroutine |
varchar(50) |
Automatically generates an MRN number on the patient data screen. Use Rhodes Group recommended value. Typical value: ALPHA4NUMBER4 |
PasswordExpirationDays |
int |
Number of days before a user password expires and must be reset. Use an integer. |
Def_Areacode |
varchar(50) |
Default for area code. Use an integer, a valid area code. Used on the patient demographic screen if area code is not provided. |
AutoOrderCodeWhenCCDoc |
varchar(50) |
Used to order tests automatically when copy to physician is used on the order screen. Multidimensional pipe delimited value. Use valid order test codes separated by pipes with leading and trailing pipes. |
MrNumMask |
varchar(50) |
Medical record number mask used to validate the MRN field on the order screen. Use “#” to represent numbers and “@” to represent alpha characters. Typical setting: @@@@#### |
CallToOrderCode |
varchar(50) |
Used in the mini window for call/fax to automatically order a test code when the CALL button is clicked on the order screen. |
FaxToOrderCode |
varchar(50) |
Used in the mini window for call/fax to automatically order a test code when the FAX button is clicked on the order screen. |
FastingOrderCode |
varchar(50) |
Used to automatically order a test if the fasting priority is selected at the order level on the order screen. The rule is activated at the time the VERIFY button is clicked. Use a valid order code. |
PastOrderDays |
int |
Number of days back that the system will allow a user to create a new order. Use an integer. The collection date is evaluated and if the order is too old, a warning message will be displayed. |
FutureOrderDays |
int |
Number of days in the future that the system will allow a user to create a new order. Use an integer. The collection date is evaluated and if the order is too far in the future, a warning message will be displayed. |
ReqID_Mask |
varchar(50) |
Mask used to validate the requisition ID on the order screen. Use “#” to represent numbers and “@” to represent alpha characters. Typical setting: ######## This setting requires an 8 character numeric only entry. |
ReqID_Exclude_Characters |
varchar(80) |
Defines the characters to exclude from the requisition ID value. Multidimensional COMMA delimited value. Use the characters, separated by commas, that should be excluded from the requisition ID value on the order screen. |
ReqID_Length_Range |
varchar(50) |
Represents the minimum and maximum number of characters allowed in the requisition ID field on the order screen. Use an integer then a dash then an integer. Do not enter a value here if an edit mask is defined for the requisition ID field. IE: 10-15 If the value is "10-15", then an entry between 10 and 15 characters long is allowed. |
DefaultPerformingLab |
varchar(50) |
Default performing lab code value. Use a valid performing lab code value. Used to supply a performing lab code to the system when one is required and not provided by rules. |
DefaultBatchDestination |
varchar(50) |
Default batch destination code. Use a valid batch destination code. Used if not provided by rules for transport logic. |
AccessionFormat |
varchar(50) |
Drives the routines that creates unique FP accessions and container IDs. Use Rhodes Group recommended value. Allowed values: ENTRYGROUPCODE = use entry group code to derive format. 7SEQ = create a 7 character unique number 8SEQ = create a 8 character unique number 9SEQ = create a 9 character unique number 10SEQ = create a 10 character unique number 11SEQ = create a 11 character unique number 12SEQ = create a 12 character unique number |
TestCompDupExcludeDept |
varchar(50) |
Excludes tests from certain departments from being evaluated for overlapping test codes if they are a battery. Multidimensional pipe delimited value. Use valid department codes separated by pipes with leading and trailing pipes. Used to order tests automatically when copy to physician is used on the order screen. IE: |BB|MC|CY|PATH| If this field is blank, the system will default to |MC|BB|CY| and will exclude those departments from test overlap/duplication logic. |
DisplayBDEFields |
varchar(50) |
Determines which fields to display in the blind duplicate entry screen. Multidimensional pipe delimited value. Use allowed values shown below separated by pipes with leading and trailing pipes. The default value of |ALL| may be used to display all fields. Allowed values: M = MRN N = pt name D = DOB S = gender T = telephone C = client L = location P = physician E = test related fields CC1 = copy to 1 CC2 = copy to 2 CC3 = copy to 3 CC4 = copy to 4 ADD = address fields |
TestCompDupExcludeTests |
varchar(500) |
Defines the test codes to exclude from the test overlap/duplication logic during order entry. Multidimensional pipe delimited value. Use valid battery test codes separated by pipes with leading and trailing pipes. Any battery test codes in this list will not be evaluated for test overlap. |
SalesTaxUserLoc |
varchar(100) |
Defines the user locations and their corresponding sales tax to be used for price calculations on the payments screen. Multidimensional pipe delimited value. Use valid user location code - sales tax percent pairs. Include a leading and trailing pipe. Each value in a pair is separated by a dash. IE: |USERLOC1-6.5|USERLOC2-6| |
LabAccessionAlphaCharacters |
varchar(50) |
Represents the letters used in the lab accession generation when FP will pre-generate it and send it to the LIS. Multidimensional pipe delimited value. Use single capital letters separated by pipes with leading and trailing pipes. IE: |A|Q|Z| |
LabAccessionFormat |
varchar(50) |
Defines format for creation of lab accession values. Use Rhodes Group recommended value. IE: 1A,8N The format "1A,8N" generates lab accessions that are one alpha character followed by 8 numeric characters. |
PaymentTypes |
varchar(100) |
Populates the payment type drop-down on the payment screen. Multidimensional pipe delimited value. Use valid payment type codes separated by pipes with leading and trailing pipes. IE: |CARD|CHECK|CASH| |
PaymentCardTypes |
varchar(100) |
Multidimensional pipe delimited value. Use valid credit card type codes separated by pipes with leading and trailing pipes. Populates the credit type drop-down on the payment screen. IE: |AMEX|VISA|DINNERS|DEBIT| |
AutoCCORDCode |
varchar(50) |
Default test code for the ordering physician when the rule is activated to order a test battery to hold the values of ordering and copy to codes. The system will automatically enter the physician code for the order if the answer test code matches this value. Use a valid test code. Used to send the ordering physician values to a client as a test code in a lab report. |
AutoCCccCode |
varchar(50) |
Default test code for copy to physician when the rule is activated to order a test battery to hold the values of ordering and copy to codes. The system will automatically enter the copy to codes for the order if the answer test code matches this value. Use a valid test code. Used to send the copy to physician values to a client as a test code in a lab report. |
CollectionLocations |
varchar(500) |
Default for collection location if not defined at the user level. Use a valid collection location. Used to evaluate the collection location entered on the order screen. |
CDCOrderEvalHours |
int |
Represents a number of hours. Use an integer. Default is 0. Used to validate the collection date/time on the order screen when a previously created order is opened. If the order collection date/time is older than this value, the collection date/time field is cleared to allow the user to enter a new one. |
PtRaceEntries |
varchar(255) |
Populates the race drop-down on the patient demographics screen. Multidimensional pipe delimited value. Use valid race codes separated by pipes with leading and trailing pipes. |
PtEthnicityEntries |
varchar(255) |
Populates the ethnicity drop-down on the patient demographics screen. Multidimensional pipe delimited value. Use valid ethnicity codes separated by pipes with leading and trailing pipes. |
FutureOrderSecsNotTriggerLabels |
int |
Represents a number of seconds. Use an integer. If the collect date/time is in the future by more than this number of seconds, no label is produced |
FutureOrderSecsAutoReceive |
int |
Represents a number of seconds. Use an integer. If the collect date/time is in the future by more than this number of seconds, the accession is excluded from auto receive processes. |
CID_Prefix |
varchar(50) |
Prefix characters for ContainerID. |
ExceptionExecFolder |
varchar(255) |
Pathway for CSTools installation. |
ExceptionExecutable |
varchar(80) |
Filename for CSTools executable. Include ".exe" in the file name. |
OrderActionPhoneNumbers |
varchar(255) |
Designed for use in TEST area. Multidimensional pipe delimited value. Use phone numbers, separated by pipes, to limit user’s choice of entry. Include leading and trailing pipes. |
RecognizedPrefixes |
varchar(255) |
Defines the prefixes to remove from patient last name in patient matching rules. Storage of prefix depends on permission. Multidimensional pipe delimited value. Use acceptable patient last name prefixes separated by pipes with leading and trailing pipes. |
RecognizedSuffixes |
varchar(255) |
Defines the suffixes to remove from patient last name in patient matching rules. Storage of suffixes depends on permission. Multidimensional pipe delimited value. Use acceptable patient last name suffixes separated by pipes with leading and trailing pipes. |
OrderCollectLocationTypes |
varchar(255) |
Populates the collection type drop-down on the patient collection location screen. Multidimensional pipe delimited value. Use valid collection type codes separated by pipes with leading and trailing pipes. |
SendOrderForFPCancelToLIS |
bit |
Bit flag to indicate if FAST should trigger a new order message before a cancel message when sending cancellation to LIS. This would only be true for orders that have not been previously sent to the LIS or have originated in LIS. The system will evaluate both of these conditions by checking to see if the IFTriggerUpdate field has been filled at the test level. 0 = do not trigger NW order before cancel 1 = trigger NW Order before sending cancel |
TriggerCancelCDCOutbound |
bit |
Bit flag to indicate if FAST should trigger cancellation messages to the outbound CDC interface for orders where FO_Accessions.Origin equals ‘C’ or ‘T’. 0 = do not trigger cancellation messages to outbound CDC 1 = trigger cancellation messages to outbound CDC |
TDC_In_Interfaces |
varchar(255) |
Interface code for Trusted Data Concentrator inbound interface Code is used by FAST to write to trigger table and must match what is expected for interface to function. |
TDC_Out_Interfaces |
varchar(255) |
Interface code for Trusted Data Concentrator outbound interface. Code is used by FAST to write to trigger table and must match what is expected for interface to function. |
CDC_In_Interfaces |
varchar(255) |
Interface code for Client Data Concentrator inbound interface. Code is used by FAST to write to trigger table and must match what is expected for interface to function. |
CDC_Out_Interfaces |
varchar(255) |
Interface code for Client Data Concentrator outbound interface. Code is used by FAST to write to trigger table and must match what is expected for interface to function. |
CDC_OUT_Cancel_Order_Control ((Please check this definition))
|
varchar(50) |
Use OC or CA OC = OrderControl when FAST writes a cancellation trigger CA = Cancellation order control to be used in FO_IF_Trigger_CDCOutbound |
RecentPatientSearchType |
varchar(50) |
Default RECENT PTS search type. Allowed values: USERLOCATION ENTRYGROUPCODE PTACCESSGROUP MPI |
RecentPatientSearchDays |
varchar(50) |
Default number of days to evaluate for recent activity. Use an integer. Used with RECENT PTS search option. Based on edit date not create date. |
UseInterfaceTriggerService |
bit |
Bit flag to indicate if FAST should enable FAST Interface Trigger Layer. Used in conjunction with FAST Interface Trigger Process Service. 0 = do not use trigger layer (FAST will continue to write to trigger table) 1 = use FAST Interface Trigger Layer and FAST Interface Trigger Process Service (started configured and separately) (New background service for creating application to interface subsystem triggers. When this is set the application writes general triggers for the background job to process in the table FO_IF_AppTrigger_Queue. The background job then creates the explicit table updates and the triggering to the FO_ID_Trigger table.) |
ProvCodesTriggerFreeText |
varchar(255) |
Defines provider codes for which a freetext provider name is allowed. Multidimensional pipe delimited value. Use valid provider codes separated by pipes with leading and trailing pipes. |
UseClientDrivenOrderScreen |
bit |
Bit flag to indicate if client-driven order screen is default order screen. 0 = use original FAST order screen 1 = use client-driven order screen |
UnknownCollectDate |
date |
Date sent to LIS when Unknown Collection box is checked. Enter collect date as MM/DD/YYYY format. |
UnknownCollectTime |
varchar(50) |
Time sent to LIS when Unknown Collection box is checked. Enter collect time as HH:MM 24-hour format. |
SpecimenPresentsDefTechCode |
varchar(50) |
Default tech code for collection tech in the Specimen Presents mode. Use a valid tech code. |
MaxOrderCopyToProvs |
varchar(50) |
Defines the maximum number of 'Copy To' providers allowed per order. Use an integer from 0 to 10. |
FPtoRREInterfaceCode |
varchar(50) |
Interface code for the Fast to RRE interface service. |
LabRegionCode |
varchar(50) |
Connects a lab code to a larger organization charting process. Use a valid region code as defined in an organizations chart. |
LabDivisionCode |
varchar(50) |
Connects a lab code to a larger organization charting process. Use a valid division code as defined in an organizations chart. |
LabSubDivisionCode |
varchar(50) |
Connects a lab code to a larger organization charting process. Use a valid sub-division code as defined in an organizations chart. |
DefaultFeeSchedule |
varchar(80) |
Default fee schedule for multiple fee schedule implementations. |
DefaultFeeScheduleOption |
varchar(80) |
Default option in the default fee schedule for multiple fee schedule implementations. |
WorkFlowMethods |
varchar(255) |
Workflow methods used by the site. Populates the workflow method drop-down on the integrated search page. Multidimensional pipe delimited value. Use allowed values as shown below separated by pipes with leading and trailing pipes. Allowed values: PATIENT PRESENTS SPECIMEN PRESENTS INDUSTRIAL TOX |
DefaultWorkFlowMethod |
varchar(50) |
System default workflow. Overridden by a user location or user-defined default workflow. Allowed values: PATIENT PRESENTS SPECIMEN PRESENTS INDUSTRIAL TOX |
ITOXDefProviderCode |
varchar(50) |
Default provider code for orders placed while in ITOX workflow. Use valid provider code. |
ITOXDefICDCodeq |
varchar(50) |
Default diagnosis code for orders placed while in ITOX workflow. Use valid diagnosis code. |
PatientFeeSchedule |
varchar(80) |
Default fee schedule code applied to Fast accessions labeled with a billto value of 'Patient/Guarantor'. Use valid fee schedule code. |
PatientFeeScheduleOption |
varchar(80) |
Default fee schedule option applied to Fast accessions labeled with a billto value of 'Patient/Guarantor'. Use valid fee schedule option. |
CashFeeSchedule |
varchar(80) |
Default fee schedule code applied to Fast accessions labeled as 'Bill to Cash'. Use valid fee schedule code. |
CashFeeScheduleOption |
varchar(80) |
Default fee schedule option applied to Fast accessions labeled as 'Bill to Cash'. Use valid fee schedule option. |
PaymentReceiptExternalFormCode |
varchar(50) |
The form code from FO_External_Form_Definition. ExternalFormCode that can be used to show a user customized SSRS-based payment receipt form. |
PtDefaultDOB |
date |
Default DOB. Enter DOB as MM/DD/YYYY format. |
BatchListRPTExteranlFormCode |
varchar(50) |
The form code from FO_External_Form_Definition. ExternalFormCode that can be used to show a user customized SSRS-based Batch List form. Leave blank to use the default report. |
DispatchListRPTExternalFormCode |
varchar(50) |
The external form code for the dispatch list user custom report. |